﻿CREATE PROCEDURE [dbo].[InsertCargo]
	(@Name nvarchar(100), 
	@NameEng nvarchar(120), 
	@Description nvarchar(250), 
	@DescriptionEng nvarchar(250), 
	@ShortCode nchar(5), 
	@Code nchar(6), 
	@CodeGNG nchar(8), 
	@Mnemocode nvarchar(12), 
	@MnemocodeEng nvarchar(30), 
	@IsUsed bit, 
	@IsEmpty bit)
AS
BEGIN
	INSERT INTO Cargo  
		(Name,
		 NameEng, 
		 Description,
		 DescriptionEng, 
		 ShortCode, 
		 Code, 
		 CodeGNG, 
		 Mnemocode, 
		 MnemocodeEng, 
		 IsUsed, 
		 IsEmpty)
	Values
		 (@Name, 
		  @NameEng, 
		  @Description,
		  @DescriptionEng, 
		  @ShortCode, 
		  @Code, 
		  @CodeGNG,
		  @Mnemocode, 
		  @MnemocodeEng, 
		  @IsUsed, 
		  @IsEmpty)
  END
